package com.hydl.power.mapper;

import com.hydl.power.pojo.Load;
import com.hydl.power.pojo.LoadExample;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface LoadMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Load record);

    int insertSelective(Load record);

    List<Load> selectByExample(LoadExample example);

    Load selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Load record);

    int updateByPrimaryKey(Load record);
     List selectAll();

    List<Load> selectByConditions(String area,String project,String powerRoom,String dataType,String startTime,String endTime);

    /*查询日负荷分析*/
    List<Load> queryLoadByhour(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize, String cityId, String projectId, String roomId, String startTime, String endTime);
    /*查询天负荷分析*/
    List<Load> queryLoadByDay(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize, String cityId, String projectId, String roomId, String startTime, String endTime);
    /*查询月负荷分析*/
    List<Load> queryLoadByMonth(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize, String cityId, String projectId, String roomId, String startTime);

    List<Load> queryLoad(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize, String startTime, String deviceId);

    List<Load> queryloadRate(String roomId);

    List<Map> queryMaxinloadRate(String powerRoomId);
}
